Krytpo Porto Status
JY
2021-09-19
Purpose
Keep track of status of krypto portfolio over time, based on transactions combined with current price data.
- Import krypto transaction data from spreadsheet.
- Download latest price data.
- Combine to calculate theoretical profit/loss trends.
- by currency
- overall portfolio
Bitcoin
Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
- Cdn dollar value
- Get latest price data.
- Combine with cost data.
- Calculate profit and ROI.
Ethereum
Adjusted Cost Base (Avg Cost)
Price, Costs, Profits
Cardano
Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
Litecoin
Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
TOTALS
| date | currency | book_val | market_val | profit | roi |
|---|---|---|---|---|---|
| 2021-09-19 | BTC | $3,177 | $4,010 | 833 | 26% |
| 2021-09-19 | ETH | $5,954 | $15,343 | 9,388 | 158% |
| 2021-09-20 | ADA | $2,164 | $2,040 | (125) | -6% |
| 2021-09-19 | LTC | $2,305 | $2,259 | (46) | -2% |
| date | total_profit | total_roi |
|---|---|---|
| 2021-09-20 | $10,050 | 74% |